package com.orange.handler;

import java.sql.SQLException;
import java.util.List;
import java.util.Map;

import com.orange.dbhelp.page.Page;
import com.orange.modules.entity.expert.AuthExpert;

public interface AuthExpertService {

	public void insertAuthExpert(AuthExpert ae) throws SQLException;
	
	public Page<AuthExpert> queryAllExpert(Integer pageNumber,Integer pageSize , Map<String ,String> map) throws SQLException;
	
	public void deleteAuthExpert(String pid) throws SQLException;
	
	public AuthExpert queryExpertByAccount(String Account) throws SQLException;
	
	public AuthExpert queryExpertBypid(String pid) throws SQLException;
	
	public Page<AuthExpert> queryExpertByInfoPage(Map<String,String>map) throws SQLException;

	public AuthExpert queryPassBypid(String pid) throws SQLException;
	
	public void updateAuthExpert(AuthExpert ae) throws SQLException;
	
	/**
	 * 根据专家id 查询专家信息
	 * @param pid
	 * @return
	 */
	public AuthExpert queryAuthExpertInfoById(String pid);
	
	/**
	 * 批量保存专家信息
	 * @param list
	 */
	public void saveAuthExpertInfos(List<AuthExpert> list);
	
	/**
	 * 查询未绑定现场考察专家组的 所有专家信息
	 * @return
	 * @throws SQLException 
	 */
	public List<AuthExpert> queryUnAuthExpertList() throws SQLException;
	
	/**
	 * @param ecodeId
	 * @return
	 * @throws SQLException
	 */
	public AuthExpert queryExpertInfoByEcodeId(String ecodeId) throws SQLException;
	
	/**
	 * 查询未绑定材料评审专家组的 所有专家信息
	 * @return
	 * @throws SQLException 
	 */
	public List<AuthExpert> queryUnAuthExpertList_material() throws SQLException;

}
